<?php

/**
 * This is the model class for table "invcompanybranch".
 *
 * The followings are the available columns in table 'invcompanybranch':
 * @property string $CompanyID
 * @property integer $CompanyBranchSuperParentID
 * @property integer $CompanyBranchParentID
 * @property integer $CompanyBranchID
 * @property string $CompanyBranchName
 * @property string $AliasName
 * @property string $DocumentPrefix
 * @property string $Address
 * @property string $AddressLocationID
 * @property integer $isActive
 * @property string $CreatedBy
 * @property string $CreatedOn
 * @property string $LastUpdateBy
 * @property string $LastUpdateOn
 *
 * The followings are the available model relations:
 * @property Cctvcamera[] $cctvcameras
 * @property Invcompany[] $invcompanies
 * @property Gflocation $addressLocation
 * @property Invcompany $company
 */
class Invcompanybranch extends CActiveRecord
{
	/**
	 * @return string the associated database table name
	 */
	public function tableName()
	{
		return 'invcompanybranch';
	}

	/**
	 * @return array validation rules for model attributes.
	 */
	public function rules()
	{
		// NOTE: you should only define rules for those attributes that
		// will receive user inputs.
		return array(
			array('CompanyBranchSuperParentID, CompanyBranchParentID, CompanyBranchID, CreatedBy, CreatedOn', 'required'),
			array('CompanyBranchSuperParentID, CompanyBranchParentID, CompanyBranchID, isActive', 'numerical', 'integerOnly'=>true),
			array('CompanyID, AddressLocationID', 'length', 'max'=>20),
			array('CompanyBranchName, CreatedBy, LastUpdateBy', 'length', 'max'=>100),
			array('AliasName', 'length', 'max'=>50),
			array('DocumentPrefix', 'length', 'max'=>5),
			array('Address', 'length', 'max'=>150),
			array('LastUpdateOn', 'safe'),
			// The following rule is used by search().
			// @todo Please remove those attributes that should not be searched.
			array('CompanyID, CompanyBranchSuperParentID, CompanyBranchParentID, CompanyBranchID, CompanyBranchName, AliasName, DocumentPrefix, Address, AddressLocationID, isActive, CreatedBy, CreatedOn, LastUpdateBy, LastUpdateOn', 'safe', 'on'=>'search'),
		);
	}

	/**
	 * @return array relational rules.
	 */
	public function relations()
	{
		// NOTE: you may need to adjust the relation name and the related
		// class name for the relations automatically generated below.
		return array(
			'cctvcameras' => array(self::HAS_MANY, 'Cctvcamera', 'CompanyBranchID'),
			'invcompanies' => array(self::MANY_MANY, 'Invcompany', 'cctvcamerasetting(CompanyBranchID, CompanyID)'),
			'addressLocation' => array(self::BELONGS_TO, 'Gflocation', 'AddressLocationID'),
			'company' => array(self::BELONGS_TO, 'Invcompany', 'CompanyID'),
		);
	}

	/**
	 * @return array customized attribute labels (name=>label)
	 */
	public function attributeLabels()
	{
		return array(
			'CompanyID' => 'Company',
			'CompanyBranchSuperParentID' => 'Company Branch Super Parent',
			'CompanyBranchParentID' => 'Company Branch Parent',
			'CompanyBranchID' => 'Company Branch',
			'CompanyBranchName' => 'Company Branch Name',
			'AliasName' => 'Alias Name',
			'DocumentPrefix' => 'Document Prefix',
			'Address' => 'Address',
			'AddressLocationID' => 'Address Location',
			'isActive' => 'Is Active',
			'CreatedBy' => 'Created By',
			'CreatedOn' => 'Created On',
			'LastUpdateBy' => 'Last Update By',
			'LastUpdateOn' => 'Last Update On',
		);
	}

	/**
	 * Retrieves a list of models based on the current search/filter conditions.
	 *
	 * Typical usecase:
	 * - Initialize the model fields with values from filter form.
	 * - Execute this method to get CActiveDataProvider instance which will filter
	 * models according to data in model fields.
	 * - Pass data provider to CGridView, CListView or any similar widget.
	 *
	 * @return CActiveDataProvider the data provider that can return the models
	 * based on the search/filter conditions.
	 */
	public function search()
	{
		// @todo Please modify the following code to remove attributes that should not be searched.

		$criteria=new CDbCriteria;

		$criteria->compare('CompanyID',$this->CompanyID,true);
		$criteria->compare('CompanyBranchSuperParentID',$this->CompanyBranchSuperParentID);
		$criteria->compare('CompanyBranchParentID',$this->CompanyBranchParentID);
		$criteria->compare('CompanyBranchID',$this->CompanyBranchID);
		$criteria->compare('CompanyBranchName',$this->CompanyBranchName,true);
		$criteria->compare('AliasName',$this->AliasName,true);
		$criteria->compare('DocumentPrefix',$this->DocumentPrefix,true);
		$criteria->compare('Address',$this->Address,true);
		$criteria->compare('AddressLocationID',$this->AddressLocationID,true);
		$criteria->compare('isActive',$this->isActive);
		$criteria->compare('CreatedBy',$this->CreatedBy,true);
		$criteria->compare('CreatedOn',$this->CreatedOn,true);
		$criteria->compare('LastUpdateBy',$this->LastUpdateBy,true);
		$criteria->compare('LastUpdateOn',$this->LastUpdateOn,true);

		return new CActiveDataProvider($this, array(
			'criteria'=>$criteria,
		));
	}

	/**
	 * Returns the static model of the specified AR class.
	 * Please note that you should have this exact method in all your CActiveRecord descendants!
	 * @param string $className active record class name.
	 * @return Invcompanybranch the static model class
	 */
	public static function model($className=__CLASS__)
	{
		return parent::model($className);
	}
}
